﻿CREATE TABLE [flcrTM].[DEVICE_DIMENSIONS] (
    [TM_DEVICE_DIMENSIONS_ID]   INT           IDENTITY (1, 1) NOT NULL,
    [TIME_KEY]                  INT           NOT NULL,
    [DEVICE_DIMENSIONS_ID]      INT           NOT NULL,
    [AUDIT_USER]                VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]                DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]             INT           NOT NULL,
    [AUDIT_MOD_USER]            VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]            DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]         INT           NOT NULL,
    [DEVICE_PLATFORM_ID]        INT           NOT NULL,
    [DIM_UTIL_MEASURES_TYPE]    INT           NOT NULL,
    [HEIGHT]                    DECIMAL (18)  NOT NULL,
    [WIDTH]                     DECIMAL (18)  NOT NULL,
    [DEPTH]                     DECIMAL (18)  NOT NULL,
    [CLEARANCE_FRONT]           DECIMAL (18)  NOT NULL,
    [CLEARANCE_REAR]            DECIMAL (18)  NOT NULL,
    [WEIGHT_UTIL_MEASURES_TYPE] INT           NOT NULL,
    [WEIGHT_MIN]                DECIMAL (18)  NOT NULL,
    [WEIGHT_MAX]                DECIMAL (18)  NOT NULL,
    [RACK_UNITS]                INT           NOT NULL,
    [CHASSIS_SLOTS]             INT           NOT NULL
);

